select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Grass Green Ball Gown Beading Strapless Appliques Dresses of 15
Baby Pink Princess Organza Appliques Beading Quince Gowns
A-line Sweetheart Beading Appliques Ruffled Quinceanera Gown
Purple Ball Gown Sweetheart Beading Appliqued Quince Dresses
Fuchsia Appliques Ball Gown Beading Ruffled Quince Dresses
Purple Tulle Ball Gown Beading Strapless Quince Dresses
Watermelon Red Ball Gown Pick-ups Sweet 16 Dresses with Tiers
Classic Orange Red Ball Gown Appliqued Dresses for a Quince
Unique Black Beading Ball Gown Taffeta Dresses for a Quince
Embroidery Hand Made Flower Yellow Ball Gown Dresses15
Royal Blue Sweetheart Ball Gown Tulle Quinceanera Gown Dresses
Brown Floor-length Ball Gown Tulle Dresses for Quinceanera
Multi-color Ball Gown Beaded Organza Quince Dresses with Ruches
White Ball Gown Strapless Sweet Sixteen Dresses with Appliques
Yellow Green Sweetheart Ball Gown Quinceanera Gown Dresses with Beading
Purple Ball Gown Taffeta and Tulle Sweet Sixteen Dresses
Multi-color Ball Gown Ruffled Organza Quinceanera Gown Dresses
Hot Pink Ball Gown Sweet Sixteen Dresses with Embroidery
Aqua Blue Ball Gown Taffeta Sweet Sixteen Dresses with Pick-ups
Purple Off The Shoulder Ball Gown Quinceanera Gown Dresses
Rose Pink Ball Gown Floor-length Quinceanera Gown Dresses
Attractive Embroidery Ball Gown Purple Quinceanera Dresses
Wonderful Colorful Ball Gown Sweet 16 Dresses with Flowers
Free Shipping Pick Ups Ball Gown Orchid Dresses for Sweet 15
Ruffled Beaded Baby Blue Ball Gown Sweetheart Quinces Dresses
Ball Gown Pick Ups Strapless Appliqued Purple Quinces Dresses
Custom Made Beaded Ball Gown Dresses for Quince
Ball Gown Strapless Ruffled Multi-color Quinceanera Dresses
Lilac Multi-layered Quinces Dresses with Ruches and Appliques
Organza Hot Pink Pick-ups Quinceanera Party Dress with Beading